package tech.aistar.mapper;

import org.apache.ibatis.annotations.Select;
import org.springframework.stereotype.Repository;
import tech.aistar.entity.Urand;

import java.util.List;

@Repository
public interface UrankMapper {
//    @Select("select * from urank where rank_type = 'java'")
//    List<Urand> findJavaRank();
    @Select("select * from urank where rank_type = 'java'")
    List<Urand> findScore();
    @Select("select rank_level from urank u join level l on u.rank_id = l.us_id where l.level_ulevel = #{u.rank_level}")
    Integer findlevel();

    @Select("select * from urank where rank_type = 'python'")
    List<Urand> findScore1();

    @Select("select * from urank where rank_type = 'c/c++'")
    List<Urand> findScore2();

    @Select("select * from urank where rank_type = 'web'")
    List<Urand> findScore3();
    @Select("select * from urank where rank_type = 'sql'")
    List<Urand> findScore4();
}
